﻿select InventoryCarriageNumber,WeightTons,Cargo.Name,ConsigneeCode,ParkType,StartStation.Name,CarOperation.Name,SUBSTRING(OperationDate,1,2)+'.'+SUBSTRING(OperationDate,3,2)+'.'+OperationYear,SUBSTRING(OperationTime,1,2)+':'+SUBSTRING(OperationTime,3,2),OpStation.Name,DelRoad.Name,RecRoad.Name,Dis.TrainIndex,Dis.TrainNumber
from tbDislocation as Dis,Cargo,Station as StartStation,CarOperation,Station as OpStation,Road as DelRoad,Road as RecRoad
where Cargo.ShortCode=Dis.CargoCodeTariff_ShortCode and
	  StartStation.Code=Dis.StartStation_Code and
	  CarOperation.Code=Dis.OperationCode_Code and CarOperation.OperationType=Dis.OperationType_Code and
	  OpStation.Code=Dis.StationOfOperation_Code and
	  Dis.DeliveryRoad_Code=DelRoad.Code and
	  Dis.ReceiptRoad_Code=RecRoad.Code
	  ;